UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0WGp4MB112HuqF/N0C2yDTnxiYnicXvvs/ygcns/V+w='
WHERE
key_id = '9aad796760126ef27ed79820e6948a544660cc70f02498d8d3ca0df486ee6895'
AND (
token = '0WGp4MB112HuqF/N0C2yDTnxiYnicXvvs/ygcns/V+w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)