UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mKVrrb8s2mnzM2buJgffJ/h87jTxeTZCkP9wRuzZ2JE='
WHERE
key_id = '5fea4de5345f1172306b757016b3d8cbf5989c70c3ccc8281e2fc928cdbe58ee'
AND (
token = 'mKVrrb8s2mnzM2buJgffJ/h87jTxeTZCkP9wRuzZ2JE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)