UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sXO4BwYh+v5NUvGIj9KCEJCOOwuX2orHsVJq9Owr47s='
WHERE
key_id = '3930ff5332e869c559efda09424072f163ce3d0084474eb5449a29607ef8af9e'
AND (
token = 'sXO4BwYh+v5NUvGIj9KCEJCOOwuX2orHsVJq9Owr47s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)