UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pC4kmnyIUX1EQBWgVtT7ZC/wN5kupNAD+4j9v6Va2E4='
WHERE
key_id = 'b2a4e483666fca56df7ad908cfbb7c0c1ef456f3b953b983348d902ca1830a2e'
AND (
token = 'pC4kmnyIUX1EQBWgVtT7ZC/wN5kupNAD+4j9v6Va2E4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)