UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'XrMR3FHIknNKbUpDeGf11LCh2XMEy/gl9TxIo8x52GQ=' 
WHERE 
  key_id = '7aba2d88dfce1dbb76d3dd18090f774e3ab521e9242d18930e3e0d19581e673e' 
  AND (
    token = 'XrMR3FHIknNKbUpDeGf11LCh2XMEy/gl9TxIo8x52GQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032