UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wLJKy14ALr90J1FXXEE9hcl+2oL18ZKvvclc8lySdDw='
WHERE
key_id = 'ef9db507781b7cfaf1bf918f84e688e17fb313b76d0bceb461f070433fa3da40'
AND (
token = 'wLJKy14ALr90J1FXXEE9hcl+2oL18ZKvvclc8lySdDw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)