UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'HL9QhlJVdhfU8FH/Cc7YXVJvFyN57UlXXx2MghfEnUM=' 
WHERE 
  key_id = '8aec4bb7530d16e0d0c9a4462ecb26a925cacc4d39e63f9ca9fe3921dc7a3c33' 
  AND (
    token = 'HL9QhlJVdhfU8FH/Cc7YXVJvFyN57UlXXx2MghfEnUM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00015