UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fX80WyiZqZ11wBEytUSC6nFah6D5tZzMfYl4KH7UXb4='
WHERE
key_id = '09631b4ef0d00d0f88acbbbfd891390d95145e5c5c2a9e6831314d9c4b95f9e1'
AND (
token = 'fX80WyiZqZ11wBEytUSC6nFah6D5tZzMfYl4KH7UXb4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)