UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hRxp1eG5RbR+8CU4QEl3IpvgyF2UbFKEkpAGaqZ3OgY='
WHERE
key_id = '7706de2cc422d6834a925251440c91ef50199b4c3b517d578380b1e4b0e9f8a9'
AND (
token = 'hRxp1eG5RbR+8CU4QEl3IpvgyF2UbFKEkpAGaqZ3OgY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)