UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pFbBz2hzcKJXri2yX1bGS7+WorBMw4edvqwbqdq2fDU='
WHERE
key_id = 'b9a463b4851a627ae6e37a4e16263ae10ecadddefe1259c5bfd9df7e95fbdcb7'
AND (
token = 'pFbBz2hzcKJXri2yX1bGS7+WorBMw4edvqwbqdq2fDU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)