UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2zZApk1PII3ghABg+dGF+cXAKhEINXXxYvfuVPM6+p0='
WHERE
key_id = '39648b4e562e764d56d7871656d7bc9e329cd28e774fbf4ae936522b6b46cff9'
AND (
token = '2zZApk1PII3ghABg+dGF+cXAKhEINXXxYvfuVPM6+p0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)