UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZpU62AsS1xNnFhFyMppARM+ojPIDYdq+R4R78kcbxMA='
WHERE
key_id = '0dec29af491290a998324a8b68378372a90027ffff3a9ba4eacddefe572272bd'
AND (
token = 'ZpU62AsS1xNnFhFyMppARM+ojPIDYdq+R4R78kcbxMA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)