UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Q8hR7S9cPpwtAUWI/5fnYhWxOTY2DVwBH9LYQj0H8u8='
WHERE
key_id = 'e7acabb13a0744630fddd3eec191d864a199043ddc7d275b13718bec7d2bf99a'
AND (
token = 'Q8hR7S9cPpwtAUWI/5fnYhWxOTY2DVwBH9LYQj0H8u8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)