UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xg4iYFrgJEWeO6ENSBZ/G3U7qParT+khhARs97oPEPo='
WHERE
key_id = '20dcc4a23886897a5f2a20265e9edc169b911d62a4efa045b9e392d06da042a2'
AND (
token = 'Xg4iYFrgJEWeO6ENSBZ/G3U7qParT+khhARs97oPEPo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)