UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'uXrQ388r8o38c/MmV+fFfCjZ+EfPfE4sq8o02qKgjSI=' 
WHERE 
  key_id = 'd8f53b2a28fcd77f42004d9fa393ca090fc4c13f6891c5a3f818715f23a2f4ac' 
  AND (
    token = 'uXrQ388r8o38c/MmV+fFfCjZ+EfPfE4sq8o02qKgjSI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00043