UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x9mRhAaNVhkWvfmM41Rz1BIf+WbncISmFsA5K1vTWoU='
WHERE
key_id = '2513a730a7b18b26620e22e5218ae174e4fa24967aaa370d09be3397091272b6'
AND (
token = 'x9mRhAaNVhkWvfmM41Rz1BIf+WbncISmFsA5K1vTWoU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)