UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bSBWIruqGoHZcnPI8bvblSDYe785/MX4PAzHfd1ojPw='
WHERE
key_id = '149df0f8442daaf8f9b08cf79e9abe1851c517f950d35adc9af118d5751e4d6e'
AND (
token = 'bSBWIruqGoHZcnPI8bvblSDYe785/MX4PAzHfd1ojPw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)