UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Luxrh5Z5U3jOSpQY6jnSXNSU8WbshSK9yHlN4FVWVoo=' 
WHERE 
  key_id = 'd7516a659619dd4f46e4bf0efce198541b19db6be2872164eaca640cc66a27ed' 
  AND (
    token = 'Luxrh5Z5U3jOSpQY6jnSXNSU8WbshSK9yHlN4FVWVoo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034