UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x3CAPQCK6IMoKXIncttCSHXQ/4IHX2rdAqyp57ZAkvs='
WHERE
key_id = '67803cc5c259dd0fb206566a0a5bbedeec9915f97b0c199654d3e5b268e186a5'
AND (
token = 'x3CAPQCK6IMoKXIncttCSHXQ/4IHX2rdAqyp57ZAkvs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)