UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z4AMXvd2yVnQmxROQOwesmcyDwt8AXoHXq8NA08uNoM='
WHERE
key_id = '19f5c356a888d9308e444a7f39c825995f7a34b1de37003600d8638b5ba8a79b'
AND (
token = 'z4AMXvd2yVnQmxROQOwesmcyDwt8AXoHXq8NA08uNoM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)