UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'mWDw00xI89Fm+a5gakIxqlu7CA/bDQR3np3CEDS/zus=' 
WHERE 
  key_id = '6ab8dd8753b27e7305fc3b5592d6ef4ff83f232c8fa128a5daab4339c46f8799' 
  AND (
    token = 'mWDw00xI89Fm+a5gakIxqlu7CA/bDQR3np3CEDS/zus=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026