UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'NhtEc3GbOtK/ALDUIrH4pccfdvGuvgOY0DA5Ov7n0U8=' 
WHERE 
  key_id = '5e142dfeb612fddfd1fc7be94159e686e9147fdda606ec0bec0f183640934d82' 
  AND (
    token = 'NhtEc3GbOtK/ALDUIrH4pccfdvGuvgOY0DA5Ov7n0U8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00025