UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a15N5A96KeH3HnLqoKHGzpF5lRPm/jAY37Bner70YcM='
WHERE
key_id = 'c0f762b752da4bd04796d5d1f242fc92c39c8b5cf2b13079f2f0a0d871a3641f'
AND (
token = 'a15N5A96KeH3HnLqoKHGzpF5lRPm/jAY37Bner70YcM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)