UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/G9IEIOZ8qMVNGVITT9EVEwrozYmSZg2N4G2wzOjoPk='
WHERE
key_id = '4e257bb6b823f0eddb329804a2dbde1817d0a39b278f1e8112c4dc8ef6544368'
AND (
token = '/G9IEIOZ8qMVNGVITT9EVEwrozYmSZg2N4G2wzOjoPk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)