UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'fjqsfCoF7Cr7iXMdHMz3E1RPmIf2rrqJwyLHZHK8OFo=' 
WHERE 
  key_id = '590dda20a4485b8e3f049f88f4bdbc729891e83c48ab8b798e1dddce312ab376' 
  AND (
    token = 'fjqsfCoF7Cr7iXMdHMz3E1RPmIf2rrqJwyLHZHK8OFo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00036