UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3dgn27FJlRm7qErC6fn+pt/yf4DhfQCju1e+zzc60E0='
WHERE
key_id = 'e073cf9d549fb08f235e695f27859f7766179075a5db90bf021aa6c39996f4fe'
AND (
token = '3dgn27FJlRm7qErC6fn+pt/yf4DhfQCju1e+zzc60E0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)