UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'KsmEGHlCnO2ekl13/LhCma2a/9I9zp9ajnmdFbjQAPY=' 
WHERE 
  key_id = '0258d5509831b7d0b23e4654e8b37ac4a024414df4fc040a0fd683dc302501dc' 
  AND (
    token = 'KsmEGHlCnO2ekl13/LhCma2a/9I9zp9ajnmdFbjQAPY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00041