UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UDJNlrVcBHwvZSCfVgVXNc9BvXgn5unDBVhBhxreRRQ='
WHERE
key_id = 'e7890c16bc4a65093afef623dbccbbd4debd3c0c53f1a0f11399f31a5642ae38'
AND (
token = 'UDJNlrVcBHwvZSCfVgVXNc9BvXgn5unDBVhBhxreRRQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)