UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nsIvcYPh7p6Rk500NBjdnBRuUYUXxLy4xfI52XUYTDw='
WHERE
key_id = '50aa78f5c7eab81b0bf9775697443946904bed9d914757d3b60d593912cc1bd0'
AND (
token = 'nsIvcYPh7p6Rk500NBjdnBRuUYUXxLy4xfI52XUYTDw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)