UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a/QdKkxeYCoSFPpEOYNaUXqWJy2OskC8yjxkltJf0II='
WHERE
key_id = 'f31fb06940a3862843c0ff9e9da1e14949cf8dcc9b9a790e594bda494d94e7cb'
AND (
token = 'a/QdKkxeYCoSFPpEOYNaUXqWJy2OskC8yjxkltJf0II='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)