UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'afeZ4QOJah1Bfhey1mqY/E6zqxs5OF4ABlG3lodmv8s='
WHERE
key_id = '6b3a964f880f20bd2673fc979eb018023a038bce0ade530bf89fa5c9371a1286'
AND (
token = 'afeZ4QOJah1Bfhey1mqY/E6zqxs5OF4ABlG3lodmv8s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)