UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HyviPxCF4piwdB/eg9Qd6UYAvjzd3RRA90Hsnt82iy4='
WHERE
key_id = 'f6f51def6718ade79ab7da16732265d9519b233c063f02350a830c1e9ee35dbe'
AND (
token = 'HyviPxCF4piwdB/eg9Qd6UYAvjzd3RRA90Hsnt82iy4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)