UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '0Chi0t/YnvbgUkkPuCS0nTrrDcK85I60Ot+Q6h6j5TQ=' 
WHERE 
  key_id = '3541f8c084ea02749c8f1fcc389caee35d004edea0f78cf6e59ebe2f31b71594' 
  AND (
    token = '0Chi0t/YnvbgUkkPuCS0nTrrDcK85I60Ot+Q6h6j5TQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00031